MAX3D

Returns the largest value in a range of cells in the whole workbook.

MAX3D is very similar to the MAX function of Microsoft Excel. The main difference is that MAX3D considers all worksheets, while the original MAX function doesn't.

Syntax

MAX3D(range_input, include_current)

range_input - is the range for which you want to find out the largest value.

include_current - Optional. Boolean argument , either TRUE or FALSE. Decides whether the current worksheet is included in the function's consideration. TRUE means the current worksheet will be considered, and vice versa.

Remarks

• You can specify cells (range of cells) that contain numbers, empty cells, logical values, or text representations of numbers. Cells that contain error values or text that cannot be translated into numbers cause errors.
• If the range specified contains no numbers, MAX3D returns 0 (zero).

 

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]